Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

Adding and deleting a record

This section describes how to add a record to a file and delete a record from it.

To add a record to a file:

Select Add to display a blank record so you can add values to create a record.

The fields you can edit are highlighted or underlined, depending on your monitor type. Notice that the Cust-Num field contains the number 1005 as shown in the following screen. This number is created automatically via the Sequence feature in the OpenEdge Data Dictionary. The default initial value of the sequence has been set to 1000 and the incremental value to 5. Therefore, when you select Add, the number 1005 appears. If you select Add again to add another record, the next number you see is 1010, and the next one is 1015, and so forth.

Note: As necessary, you can access the OpenEdge Data Dictionary to reset the initial and incremental values to different values.



Accept the value 1005, and press RETURN to go to the next field.
Fill in the rest of the fields with the data identified in Table 3–4.

Table 3–4: Field information for new record

Field	Information
Name	Windbag Windsocks
Address	2 Flyhigh Road
City	Chicago
State1	IL
Postal-Code	60628
Contact	Ronald Scott
Phone	(312) 456-3769
Sales-Rep1	DKP
Results automatically verifies information you enter into these fields. If you try to enter an invalid value, you get an error message.

Press TAB or any cursor key to move among fields. To edit a field, simply type over existing information.

Press GO to add this record to the mysports database:

** customer already exists with Cust num 1005. (132)

Note: If there is already a customer number 1005 in the database, this error message appears:

Results automatically verifies the information you enter. If it is invalid, an error message appears. (To find an available customer number, you can use the Browse option described in the "Browsing through records" section.)

To delete a record from a file (current record - customer 1005):

Verify that customer 1005 is the current record.
Select Delete.

A window appears that prompts you to verify whether you want to delete the current record.

Select YES. Results deletes the record from the mysports database and removes it from the screen. Results displays the last record in the customer file.
Select First.